Release 10.1A: OpenEdge Development:
Progress 4GL Reference

ADD-COLUMNS-FROM( ) method

Creates a browse column for each field found in the specified buffer or table. If a field is found that already has a corresponding browse-column created, it is ignored. This method can be used only after the browse’s query attribute has been set.

Return type: LOGICAL

Applies to: BROWSE widget

Syntax

ADD-COLUMNS-FROM( buffer-hndl | table-name-exp [ , except-list ] )

buffer-hndl

The widget handle of a buffer associated with the browse’s query.

table-name-exp

The name of a table associated with the browse’s query.

except-list

An expression that evaluates to a comma-separated list of field names to be excluded from the browse. No extra spaces should be included between names.

The following is an example of adding browse columns from the Invoice table, excluding the fields, Amount and Total-Paid:

DEFINE VARIABLE ExcList AS CHARACTER INITIAL "Amount,Total-Paid". ... AddCol = BrwsHndl:ADD-COLUMNS-FROM("invoice", ExcList).

Notes

The ADD-COLUMNS-FROM( ) method may be used on a static browse as well as on a dynamic browse. When used on a static browse, the browse will become a NO-ASSIGN browse (you must make the database updates.)
A dynamic browse column’s validation expression is restricted. It may not contain a CAN-FIND function. To reference the field, the FRAME-VALUE function must be used.